﻿CREATE TABLE [dbo].[FloatDataUpdates]
(
	[Time] DATETIME2 NOT NULL , 
    [TagId] BIGINT NOT NULL, 
    [OldValue] FLOAT NOT NULL, 
    [NewValue] FLOAT NOT NULL, 
    [Comments] NVARCHAR(MAX) NULL, 
    [ModifiedAt] DATETIME2 NOT NULL, 
    [ModifiedBy] BIGINT NOT NULL, 
    PRIMARY KEY ([Time], [TagId], [ModifiedAt]), 
    CONSTRAINT [FK_FloadDataUpdateToTag] FOREIGN KEY ([TagId]) REFERENCES [Tag]([Id])
)
